This is an excel template for a 4-month project schedule (gantt chart) which can avoid holidays automatically.

You input the holidays and the chart will show the shaded vertical bars on these days. You then input the durations and the start dates. The end dates will be generated automatically and the horizontal task bars will avoid the holidays. If a task with 3 days of duration meets 2 holidays, the task bar will extend to 5 calendar days.

The spreadsheet is stored in the virus-free Google drive and can be downloaded from the link below.

Click this: Download Now

My email address: samuelkin001@gmail.com